package com.liu.mapper;

import com.liu.pojo.Article;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface ArticleMapper {

    @Insert("insert into article(title,content,cover_img,state,category_id,create_user,create_time,update_time) " +
            "values(#{title},#{content},#{coverImg},#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})")
    void add(Article article);

//    此处是分页查询，将使用映射文件中的sql语句进行拼接，然后使用mybatis的动态sql进行查询
    List<Article> list(Integer userId, Integer categoryId, String state);
}
